//验证数据库中用户相关内容
const User = {
    //查询手机号
    queryUserTel (option) {
        return 'select * from user where tel = ' + option.userTel + ''
    },
    //查询密码
    queryUserPwd (option) {
        return 'select * from user where (tel = ' + option.userTel + ') and pwd = ' + option.userPwd + ''
    },
    //新增用户
    insertData (option) {
        let userTel = option.userTel
        let userPwd = option.userPwd || '666666'
        //引入token包
        let jwt = require('jsonwebtoken')
        //用户信息
        let payload = { tel: userTel }
        //口令
        let secret = 'drinkGoodTea'
        //生成token
        let token = jwt.sign(payload, secret, { expiresIn: '24h' })


        //返回添加用户的sql语句
        return 'insert into user (tel,pwd,imgUrl,nickName,token) values("' + userTel + '","' + userPwd + '","/images/user.jpeg","' + userTel + '","' + token + '")'
    }

}

module.exports = User